Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
MerchandiseHierarchyFunctionID (PK) | A unique system assigned identifier for the MerchandiseHierarchyFunction | id_mrhrc_fnc | Identity | int | |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | ItemDimension(ETL_DW3_DIM_ITM) |
MerchandiseHierarchyFunctionName | The name of MerchandiseHierarchyFunction | NM_MRHRC_FNC | DescriptionShort | varchar(255) | |
ParentMerchandiseHierarchyLevelID | A unique system assigned identifier for the Level within the merchandise hierarchy tree. | id_mrhrc_lv_prnt | Identity | int | |
ChildMerchandiseHierarchyGroupID | Unique system assigned identifier for a group or class of merchandise. | id_mrhrc_gp_chld | Identity | int | |
ParentMerchandiseHierarchyGroupID | Unique system assigned identifier for a group or class of merchandise. | id_mrhrc_gp_prnt | Identity | int | |
MerchaniseHierarchyIDTreePath | A pipe delimited, bottom up (left to right) list of merchandise hierarchy level ID's ina merchandise hierarchy. | MRCHRC_ID_TREE_PTH | String | varchar(4000) | |
MerchandiseHierarchyLevelPath | A pipe delimited, bottom up (left to right) list of merchandise hierarchy level numbers in a merchandise hierarchy | MRHRC_LVL_PTH | String | varchar(4000) | |
MerchandiseHierarchyLevelNamePath | A pipe delimited, bottom up (left to right) list of merchandise hierarchy level NAMES (metadata description/name of levels in a hierarchy) for a merchandise hierarchy. | MRHRC_LV_NM_PTH | String | varchar(4000) | |
MerchandiseHierarchyGroupNamePath | A pipe delimited, bottom up (left to right) list of merchandise hierarchy level group NAMES for a merchandise hierarchy. | MRHRC_LVL_GP_NM_PTH | String | varchar(4000) | |
MerchandiseHierarchyRootCode | A derived attribute that indicates that you are at the ROOT for agiven merchandise hierarchy. | CD_MRHRC_ROOT | String | varchar(4) | |
ItemName | A combination of ItemID and ItemName for display purposes. This is a derived attribute (created in an ETL view). | ITM_ID_NM | String | varchar(75) | |